Integration flow database runtime

ABSTRACT

The present disclosure describes methods, systems, and computer program products for providing application integration functionality directly on a relational database according to an implementation. One computer-implemented method includes inserting relational data into a start table of a database, detecting a change in the start table, retrieving the inserted relational data from the start table, processing, using a computer, the relational data using a database integration flow runtime into result data, inserting the result data into an end table of the database, detecting a change in the end table, and retrieving the result data from the end table.

BACKGROUND

Enterprise Application Integration (EAI) solutions attempt to facilitatecommunication between homogeneous/heterogeneous applications. The EAIsolutions often use a generic data exchange (GDX) format, such as XML,as their canonical data model and an EAI solution runtime is typicallymessage-oriented middleware (MOM) or an Enterprise Service Bus (ESB)built on top of an application server. If a system (sender) needs tosend data in a message using a particular EAI solution to an application(receiver), the data may be converted multiple times between, forexample, database relational format and GDX format and cross multiplesystem boundaries (sender database-to-application server, applicationserver-to-EAI solution, EAI solution-to-application server, applicationserver-to-receiver database), resulting in high resource overhead permessage to the receiver. The needed software, hardware, and support aswell as system complexity increase a total cost of ownership for EAIsolutions for both senders and receivers.

SUMMARY

The present disclosure relates to computer-implemented methods,computer-readable media, and computer systems for providing applicationintegration functionality directly on a relational database. Onecomputer-implemented method includes inserting relational data into astart table of a database, detecting a change in the start table,retrieving the inserted relational data from the start table,processing, using a computer, the relational data using a databaseintegration flow runtime into result data, inserting the result datainto an end table of the database, detecting a change in the end table,and retrieving the result data from the end table.

Other implementations of this aspect include corresponding computersystems, apparatuses, and computer programs recorded on one or morecomputer storage devices, each configured to perform the actions of themethods. A system of one or more computers can be configured to performparticular operations or actions by virtue of having software, firmware,hardware, or a combination of software, firmware, or hardware installedon the system that in operation causes or causes the system to performthe actions. One or more computer programs can be configured to performparticular operations or actions by virtue of including instructionsthat, when executed by data processing apparatus, cause the apparatus toperform the actions.

The foregoing and other implementations can each optionally include oneor more of the following features, alone or in combination:

A first aspect, combinable with the general implementation, furthercomprising selecting the relational data from a source table of thedatabase.

A second aspect, combinable with any of the previous aspects, furthercomprising inserting the result data into a target table of thedatabase.

A third aspect, combinable with any of the previous aspects, furthercomprising serializing the result data, passing the serialized data to atransmission application, and transmitting the serialized data.

A fourth aspect, combinable with any of the previous aspects, furthercomprising deserializing received data into relational data.

A fifth aspect, combinable with any of the previous aspects, serializingthe result data for transmission, passing the serialized data to atransmission application, and transmitting the serialized data.

The subject matter described in this specification can be implemented inparticular implementations so as to realize one or more of the followingadvantages. First, all operations are database-internal. Nosystem-boundaries are typically traversed and no data conversion isrequired between a relational format and a general data exchange (GDX)format; resulting in a lower resource footprint. In case a sender and areceiver do not share the same database system, data can be transportedin relations format from the sender to the receiver database. Second,all data-intensive operations are executed in a database system wherethe database system acts as an integration runtime. Third, the databaseruntime leverages well-established database management system (DBMS)principles, such as parallel query execution and scalability for highperformance, a rich set of abstract languages (sequential query language(SQL) and stored procedures) to define integration semantics, ACIDprinciples for transactional data processing, and user/role managementfor access control. Fourth, a database-based integration runtimeinherits some of the characteristics of the database used, includinghigh availability, stability, persistence, and bulk processing. Fifth,the execution of application integration functionality directly on arelational database and the ability to forego the use of a dedicatedapplication server results in a lower total cost of ownership forapplication integration. Other advantages will be apparent to thoseskilled in the art.

The details of one or more implementations of the subject matter of thisspecification are set forth in the accompanying drawings and thedescription below. Other features, aspects, and advantages of thesubject matter will become apparent from the description, the drawings,and the claims.

DESCRIPTION OF DRAWINGS

FIG. 1 is a block diagram illustrating an example distributed computingsystem for providing application integration functionality directly on arelational database according to an implementation.

FIG. 2 is a flow chart of an example integration flow (iFlow)compilation according to an implementation.

FIGS. 3A & 3B are block diagrams illustrating design-time and run-timeaspects of a provided splitter-aggregator iFlow diagram compiled to adatabase according to an implementation.

FIG. 4 is a block diagram of a category 1 (C-1) integrationconfiguration according to an implementation.

FIG. 5 is a block diagram of a category 2 (C-2) integrationconfiguration according to an implementation.

FIG. 6 is a block diagram of a category 3 (C-3) integrationconfiguration according to an implementation.

FIG. 7 is a block diagram of a current state integration configurationaccording to an implementation.

FIG. 8 is a flow chart illustrating a method for providing C-1application integration functionality (as illustrated in FIG. 4)directly on a relational database according to an implementation.

FIG. 9A is a flow chart illustrating a method for providing C-2application outbound integration functionality (as illustrated in FIG.5) directly on a relational database according to an implementation.

FIG. 9B is a flow chart illustrating a method for providing C-2application inbound integration functionality (as illustrated in FIG. 5)directly on a relational database according to an implementation.

FIG. 10 is a flow chart illustrating a method for providing C-3application integration functionality (as illustrated in FIG. 6)directly on a relational database according to an implementation.

Like reference numbers and designations in the various drawings indicatelike elements.

DETAILED DESCRIPTION

This disclosure generally describes computer-implemented methods,computer-program products, and systems for providing applicationintegration functionality directly on a relational database. Thefollowing description is presented to enable any person skilled in theart to make and use the invention, and is provided in the context of oneor more particular implementations. Various modifications to thedisclosed implementations will be readily apparent to those skilled inthe art, and the general principles defined herein may be applied toother implementations and applications without departing from scope ofthe disclosure. Thus, the present disclosure is not intended to belimited to the described and/or illustrated implementations, but is tobe accorded the widest scope consistent with the principles and featuresdisclosed herein.

Enterprise Application Integration (EAI) solutions attempt to facilitatecommunication between homogeneous/heterogeneous applications. EAIsolutions often use a generic data exchange (GDX) format, such as XML,as their canonical data model and an EAI solution runtime is typicallymessage-oriented middleware (MOM) or an Enterprise Service Bus (ESB)built on top of an application server, if a system (sender) needs tosend data in a message using a particular EAI solution to an application(receiver), multiple (simplified) processing steps are typicallynecessary: 1) the sender extracts sender-relational-format data to besent from a sender database; 2) the sender converts the extractedsender-relational-format data to an EAI-compatible, GDX-formatted firstmessage; 3) the sender passes the converted data to a particular EAIsolution (which runs on its own software stack) in the EAI-compatible,GDX-formatted first message; 4) the EAI solution processes the receiveddata retrieved from the EAI-compatible, GDX-formatted first message(e.g., transformation, receiver determination, and the like) using EAIsolution logic/EAI solution database; 5) the EAI solution passes thedata in a receiver-compatible, GDX-formatted second message to thereceiver; 6) the receiver converts the data in the receiver-compatible,GDX-formatted second message to a receiver-compatible relational format;and 7) the receiver inserts the data into its database using thereceiver-compatible relational format. In total, the data is convertedtwice (sender relational format-to-EAI-compatible, GDX-format andreceiver-compatible, GDX-format-to-receiver relational format) andcrosses four system boundaries (sender database-to-application server,application server-to-EAI solution, EAI solution-to-application server,application server-to-receiver database), resulting in high resourceoverhead per message to the receiver. The needed software, hardware, andsupport as well as system complexity increase a total cost of ownershipfor EAI solutions for both senders and receivers. The followingdescribed computer-implemented methods, computer-readable media,computer systems, and components of an example distributed computersystem (ECDS) provide functionality to execute engineering applicationintegration (EAI) directly on a relational database and not on anapplication server. In some implementations, the functionality can beprovided with and/or use one or more graphical user interfaces (GUIs)providing an efficient and user-friendly data input capability and/orpresentation of data provided by or communicated within the EDCS 100.

FIG. 1 is a block diagram illustrating an example distributed computingsystem (EDCS) 100 for providing application integration functionalitydirectly on a relational database according to an implementation. Theillustrated EDCS 100 includes or is communicably coupled with one ormore application servers 102, one or more clients 140, and one or moredatabase servers 150 that communicate across a network 130. In otherimplementations, other appropriate computing components can be coupledto the EDCS 100. In some implementations, the EDCS 100 can be acloud-computing environment.

At a high level, the application server 102 is an electronic computingdevice within the EDCS 100 that is operable to receive, transmit,process, store, or manage data and information. According to someimplementations, the application server 102 may be, include, and/or becommunicably coupled with an e-mail server, a web server, a cachingserver, a streaming data server, and/or other suitable server. Theapplication server 102 may operate in a cloud-based computingenvironment.

In general, the application server 102 is a server that stores and/orexecutes one or more applications 108 responsive to requests/responsessent by other application servers 102 (e.g., from a client application(described below)), clients 140, database servers 150 and/or othercomponents (whether illustrated or not) within and communicably coupledto the illustrated EDCS 100. For example, requests/responses can, insome implementations, be messages. In some implementations, the messagescan be structured according to the extensible markup language (XML)and/or other suitable format, protocol, etc. In some implementations,application server 102 can be accessed directly or using the network 130to perform programmed tasks or operations of a particular application108 and/or associated component (whether illustrated or not).Requests/responses may also be sent to the application server 102 frominternal users, external or third-parties, other automated applications,as well as any other appropriate entities, individuals, systems, orcomputers (whether illustrated or not).

In some implementations, any and/or all components of the applicationserver 102, both hardware and/or software, may interface with each otherand/or the interface using an application programming interface (API)and/or a service layer (neither illustrated). The API may includespecifications for routines, data structures, and object classes. TheAPI may be either computer-language independent or dependent and referto a complete interface, a single function, or even a set of APIs. Theservice layer provides software services to the EDCS 100. Thefunctionality of the application server 102 may be accessible for allservice consumers using this service layer. Software services, such asthose provided by the service layer, provide reusable, defined businessfunctionalities through a defined interface. For example, the interfacemay be software written in JAVA, C++, or other suitable languageproviding data in extensible markup language (XML) format or othersuitable format. The API and/or service layer can be wholly or partialintegral or stand alone in relation to the application server 102 orcomponents of the EDCS 100. Moreover, any or all parts of the API and/orthe service layer may be implemented as child or sub-modules of anothersoftware module, enterprise application, or hardware module.

The application server 102 includes an interface 104. Althoughillustrated as a single interface 104 in FIG. 1, two or more interfaces104 may be used according to particular needs, desires, or particularimplementations of the EDCS 100. The interface 104 is used by theapplication server 102 for communicating with other systems in adistributed environment—including within the EDCS 100—connected to thenetwork 130; for example, the client 140, database server 150, as wellas other systems (whether illustrated or not) that may be communicablycoupled to the network 130. Generally, the interface 104 comprises logicencoded in software and/or hardware in a suitable combination andoperable to communicate with the network 130. More specifically, theinterface 104 may comprise software supporting one or more communicationprotocols associated with communications such that the network 130 orinterface's hardware is operable to communicate physical signals withinand outside of the illustrated EDCS 100.

The application server 102 includes a processor 105. Althoughillustrated as a single processor 105 in FIG. 1, two or more processorsmay be used according to particular needs, desires, or particularimplementations of the EDCS 100. The processor 105 executes instructionsand manipulates data to perform the operations of the application server102 and/or functionality required to provide application integrationfunctionality directly on a relational database.

The application server 102 also includes a memory 106 that holds datafor the application server 102, client 140, database server 150, and/orother components of the EDCS 100 (whether illustrated or not). Althoughillustrated as a single memory 106 in FIG. 1, two or more memories maybe used according to particular needs, desires, or particularimplementations of the EDCS 100. While memory 106 is illustrated as anintegral component of the application server 102, in alternativeimplementations, memory 106 can be external to the application server102 and/or the EDCS 100. In some implementations, the memory 106includes one or more instances of application data 114.

The application 108 is any type of application that allows the client140, database server 150, and/or other component(s) of the EDCS 100 torequest, view, add, edit, delete, manage, and/or consume contentobtained from/by the application server 102 in response to a receivedrequest/response. For example, the application 108 may be a portalapplication, a business application, and/or other suitable applicationconsistent with this disclosure. The application 108 can also interfacewith other applications 108 and/or other suitable components of the EDCS100 to wholly or partially complete a particular task. For example, thedescribed components can provide functionality to provide and/or supportapplication integration functionality directly on a relational database.

In some implementations, the application 108 can also be associated withapplication data 114, including objects and data, user profiles,processes, content provider locations, addresses, data storagelocations/specifications, content lists, access requirements, and/or anyother suitable data associated with an application 108. The applicationdata 114 can be represented by any type of suitable data structure(s)and in any suitable format(s). For example, the application data 114could be an executable module, spreadsheet, database, flat file, binaryfile, multi-part file, linked list, and/or the like.

Once a particular application 108 is launched, a client 140 and/ordatabase server 150 may interactively process a task, event, or otherinformation associated with the application server 102 associated withthe application 108. Additionally, a particular application 108 mayoperate in response to and in connection with at least one requestreceived from other applications 108, including applications 108 orother components (e.g., software and/or hardware modules) associatedwith another application server 102. In some implementations, theapplication 108 can be and/or include a web browser. In someimplementations, each application 108 can represent a network-basedapplication accessed and executed using the network 130 (e.g., throughthe Internet, or using at least one cloud-based service associated withthe application 108). For example, a portion of a particular application108 may be a web service associated with the application 108 that isremotely called, while another portion of the application 108 may be aninterface object or agent bundled for processing at a remote client 140.Moreover, any or all of a particular application 108 may be a child orsub-module of another software module without departing from the scopeof this disclosure. Still further, portions of the particularapplication 108 may be executed or accessed by a user working directlyat the application server 102, as well as remotely at a correspondingclient 140 and/or database server 150. In some implementations, theapplication server 102 or any suitable component of application server102 or the EDCS 100 can execute the application 108.

The client 140 (e.g., 140 a-140 c) may be any computing device operableto connect to or communicate with at least the application server 102using the network 130. In some implementations, the client 140 cancommunicate directly with the database server 150 or indirectly throughanother component of the EDCS 100. In general, the client 140 comprisesan electronic computing device operable to receive, transmit, process,and store any appropriate data associated with the EDCS 100. Typicallythe client 140 will process and/or respond (both automatically and/or bymanual user interaction) to requests and/or responses generated by theapplication server 102, for example software code received from theapplication 108. The client 140 can also initiate requests to theapplication server 102 and/or database server 150. The client 140typically includes a client application 146, processor 144, a memory148, and/or an interface 149.

The client application 146 is any type of application that allows theclient 140 to navigate to/from, request, view, edit, delete, and ormanipulate content on the client 140, for example using an HTML 5-,IOS-, or ANDROID-based application. In some implementations, the clientapplication 146 can be and/or include a web browser. In someimplementations, the client-application 146 can use parameters,metadata, and other information received at launch to access aparticular set of data from the application server 102, database server150, and/or other client 140. Once a particular client application 146is launched, a user may interactively process a task, event, or otherinformation associated with the application server 102, database server150, and/or other client 140. Further, although illustrated as a singleclient application 146, the client application 146 may be implemented asmultiple client applications in the client 140. In some implementations,the client application 146 may act as a GUI interface for theapplication 108, database server 150, and/or other components (whetheror not illustrated) of the EDCS 100.

The interface 149 is used by the client 140 for communicating with othercomputing systems within the EDCS 100, using network 130. For example,the client 140 can use the interface 149 to communicate with theapplication server 102, database server 150, as well as other clients140 and/or systems (not illustrated) that can be communicably coupled tothe network 130. The interface 149 may be consistent with theabove-described interface 104 of the application server 102 or otherinterfaces (whether illustrated or not) within the EDCS 100. Theprocessor 144 may be consistent with the above-described processor 105of the application server 102 or other processors (whether illustratedor not) within the EDCS 100. Specifically, the processor 144 executesinstructions and manipulates data to perform the operations of theclient 140, including the functionality required to send requests to theapplication server 102 and/or database server 150, and to receive andprocess responses from the application server 102 and/or databaseserver. The memory 148 typically stores objects and/or data associatedwith the purposes of the client 140 but may also be consistent with theabove-described memory 106 of the application server 102 or othermemories (whether or not illustrated) within the EDCS 100, and can beused to store data similar to that stored in the other memories of theEDCS 100 for purposes such as backup, caching, and the like.

Further, the illustrated client 140 includes a GUI 142. The GUI 142interfaces with at least a portion of the EDCS 100 for any suitablepurpose, including generating a visual representation of a web browserand/or other GUI interface. The GUI 142 may be used to view and navigateamong various web pages located both internally and externally to theapplication server 102/database server 150, view data associated withthe application server 102, database server 150, and/or the client 140,or for any other suitable purpose. In particular, the GUI 142 may beused in conjunction with content from application server 102, databaseserver 150, and/or the client 140 to provide application integrationfunctionality directly on a relational database.

There may be any number of clients 140 associated with, or external to,the EDCS 100. For example, while the illustrated EDCS 100 includes oneclient 140 communicably coupled to the application server 102 anddatabase server 150 using network 130, alternative implementations ofthe EDCS 100 may include any number of clients 140 suitable to thepurposes of the EDCS 100. Additionally, there may also be one or moreadditional clients 140 external to the illustrated portion of the EDCS100 that are capable of interacting with the EDCS 100 using the network130. Further, the term “client” and “user” may be used interchangeablyas appropriate without departing from the scope of this disclosure.Moreover, while the client 140 is described in terms of being used by asingle user, this disclosure contemplates that many users may use onecomputer, or that one user may use multiple computers.

The illustrated client 140 (some example configurations illustrated as140 a-140 c) is intended to encompass any computing device such as adesktop computer, laptop/notebook computer, wireless data port, smartphone, personal data assistant (PDA), tablet computing device, one ormore processors within these devices, or any other suitable processingdevice. For example, the client 140 may comprise a computer thatincludes an input device, such as a keypad, touch screen, or otherdevice that can accept user information, and an output device thatconveys information associated with the operation of the applicationserver 102 or the client 140 itself, including digital data, visualand/or audio information, or a GUI 142, as shown with respect to theclient 140.

In some implementations, any and/or all components of the client 140,both hardware and/or software, may interface with each other and/or theinterface using an application programming interface (API) and/or aservice layer (neither illustrated). The API may include specificationsfor routines, data structures, and object classes. The API may be eithercomputer-language independent or dependent and refer to a completeinterface, a single function, or even a set of APIs. The service layerprovides software services to the EDCS 100. The functionality of theclient 140 may be accessible for all service consumers using thisservice layer. Software services, such as those provided by the servicelayer, provide reusable, defined business functionalities through adefined interface. For example, the interface may be software written inJAVA, C++, or other suitable language providing data in extensiblemarkup language (XML) format or other suitable format. The API and/orservice layer can be wholly or partial integral or stand alone inrelation to the client 140 or components of the EDCS 100. Moreover, anyor all parts of the API and/or the service layer may be implemented aschild or sub-modules of another software module, enterprise application,or hardware module.

At a high level, the database server 150 is an electronic computingdevice within the EDCS 100 that is operable to receive, transmit,process, store, or manage data and information using a relationaldatabase. According to some implementations, the database server 150 maybe, include, and/or be communicably coupled with an e-mail server, a webserver, a caching server, a streaming data server, and/or other suitableserver. The database server 150 may operate in a cloud-based computingenvironment.

In general, the database server 150 is a server that stores and/orexecutes one or more IFC compilers 158 and/or modeling applications 160responsive to requests/responses sent by an application server 102,client 140, other database server 150 and/or other component (whetherillustrated or not) within and communicably coupled to the illustratedEDCS 100. The database server 150 provides application integrationfunctionality directly on an associated relational database 156. In someimplementations, database server 150 can be accessed directly or usingthe network 130 to perform programmed tasks or operations of aparticular IFC compiler 158, modeling application 160, and/or associatedcomponent (whether illustrated or not). Requests/responses may also besent to the database server 150 from internal users, external orthird-parties, other automated applications, as well as any otherappropriate entities, individuals, systems, or computers (whetherillustrated or not).

In some implementations, any and/or all components of the databaseserver 150, both hardware and/or software, may interface with each otherand/or the interface using an application programming interface (API)and/or a service layer (neither illustrated). The API may includespecifications for routines, data structures, and object classes. TheAPI may be either computer-language independent or dependent and referto a complete interface, a single function, or even a set of APIs. Theservice layer provides software services to the EDCS 100. Thefunctionality of the database server 150 may be accessible for allservice consumers using this service layer. Software services, such asthose provided by the service layer, provide reusable, defined businessfunctionalities through a defined interface. For example, the interfacemay be software written in JAVA, C++, or other suitable languageproviding data in extensible markup language (XML) format or othersuitable format. The API and/or service layer can be wholly or partialintegral or stand alone in relation to the database server 150 orcomponents of the EDCS 100. Moreover, any or all parts of the API and/orthe service layer may be implemented as child or sub-modules of anothersoftware module, enterprise application, or hardware module.

The database server 150 includes an interface 152. Although illustratedas a single interface 152 in FIG. 1, two or more interfaces 152 may beused according to particular needs, desires, or particularimplementations of the EDCS 100. The interface 152 is used by thedatabase server 150 for communicating with other systems in adistributed environment—including within the EDCS 100—connected to thenetwork 130; for example, the client 140, application server 102, aswell as other systems (whether illustrated or not) that may becommunicably coupled to the network 130. Generally, the interface 152comprises logic encoded in software and/or hardware in a suitablecombination and operable to communicate with the network 130. Morespecifically, the interface 152 may comprise software supporting one ormore communication protocols associated with communications such thatthe network 130 or interface's hardware is operable to communicatephysical signals within and outside of the illustrated EDCS 100.

The database server 150 includes a processor 154. Although illustratedas a single processor 154 in FIG. 1, two or more processors may be usedaccording to particular needs, desires, or particular implementations ofthe EDCS 100. The processor 154 executes instructions and manipulatesdata to perform the operations of the database server 150 and/orfunctionality required to provide application integration functionalitydirectly on a relational database.

The database server 150 also includes a relational database 156. Therelational database 156 can, in some implementations, hold data for thedatabase server 150, client 140, application server 102, and/or othercomponents of the EDCS 100 (whether illustrated or not). In someimplementations, the relational database in an in-memory database. Thein-memory database 156 is a high-performance relational databasemanagement system (RDBMS) that primarily relies on volatile electronicmemory, such as random access memory (RAM), as opposed to magnetic,optical, removable, or other suitable non-electronic memory, forstorage, retrieval, and processing of data. The reliance on electronicmemory allows, in some implementations, for near-real-time aggregation,replication, synchronization, and processing of data. In someimplementations, a persistency layer ensures that a copy of thein-memory database is maintained on non-volatile magnetic, optical,removable, or other suitable non-electronic memory in the event of apower or other system failure in order to allow recovery of thein-memory database. In some implementations, the in-memory database 156can be replicated to one or more conventional databases (notillustrated) for backup purposes. In some implementations, data from theconventional database can be replicated to and used from the in-memorydatabase 156.

Although illustrated as a single relational database 156 in FIG. 1, twoor more relational databases 156 may be used according to particularneeds, desires, or particular implementations of the EDCS 100. While therelational database 156 is illustrated as an integral component of thedatabase server 150, in alternative implementations, relational database156 can be external to the database server 150 and/or the EDCS 100. Insome implementations, the relational database 156 includes one or moreinstances of enterprise integration pattern (EIP) constructs 162.

An EIP construct 162 is and integration semantic, or integration flow(“iFlow”), design pattern for the use of enterprise applicationintegration and MOM. The iFlow is a description or template for how tosolve a problem (e.g., integrating two applications) that can be used inmany different situations and are often formalized best practices/provendesign paradigms that a software programmer implements in a particularapplication, process, etc. iFlows are often specified as a collaborationdiagram, where a sender/receiver and the integration flow itself areparticipants. For example, an iFlow could be created to count wordswithin a message supplied by a first application (sender) and to supplythe result to a second application (receiver). The example iFlow couldhave multiple steps, each step performing a different function. In someimplementations, iFlows can be described in business process modelingnotation (BPMN) or other suitable notation. Although illustrated asintegral to the database server 150 in FIG. 1, in alternativeimplementations, the EIP constructs 162 can be external to the databaseserver 150 and/or the EDCS 100 (e.g., within a memory of the applicationserver 102, client 140, and/or separate server (not illustrated)).Examples of EIP constructs may include content-based routing, messagemapping (structure mapping), filter/split/aggregate messages (e.g., asillustrated in FIG. 3), and the like.

EIP constructs 162 are at least generated, edited, deleted, stored,and/or retrieved by a modeling application 158. The modeling application158 provides a GUI interface for efficient user interaction with themodeling application 158 and EIP constructs 162. Although illustrated asintegral to the database server 150 in FIG. 1, in alternativeimplementations, the modeling application 158 can be external to thedatabase server 150 and/or the EDCS 100 (e.g., executing on theapplication server 102, the client 140, and/or a separate server (notillustrated)). In some implementations, the GUI interface can allowspecification of a BPMN model representing integration semantics of aniFlow. In other implementations, the modeling application 158 can havean interface that receives a particular iFlow in a textualrepresentation (e.g., program code or XML).

The integration flow compiler (IFC) 160 is any type of application thatcompiles iFlows into database constructs, for example database tables(storing messages and intermediate results), structured query language(SQL) statements (integration operations), stored procedures(integration operations), stored procedures (capturing user-defined codecontaining integration semantics), database statements (e.g.,begin/commit transaction) to ensure transactional processing of themessages and to handle the lifecycle of a message, and/or storedprocedures handling the lifecycle of a message. As the iFlow isexpressed in database constructs, the database system itself acts as anintegration runtime. Note, only integration problems that can be solvedusing database constructs can be executed in the database. In someimplementations, iFlows can be “split” and compiled into a combinationof database and non-database constructs. In some instances, a databaseconstruct can be used to trigger the non-database construct and totransmit data to/receive data from the non-database construct. Althoughillustrated as integral to the database server 150 in FIG. 1, inalternative implementations, the IFC 160 can be external to the databaseserver 150 and/or the EDCS 100 (e.g., executing on the applicationserver 102, the client 140, and/or a separate server (not illustrated)).

FIG. 2 is a flow chart 200 of an example iFlow compilation according toan implementation. For clarity of presentation, the description thatfollows generally describes method 200 in the context of FIG. 1.However, it will be understood that method 200 may be performed, forexample, by any other suitable system, environment, software, andhardware, or a combination of systems, environments, software, andhardware as appropriate. In some implementations, various steps ofmethod 200 can be run in parallel, in combination, in loops, or in anyorder.

At (1), the IFC 160 receives a BPMN iFlow diagram 202. From (1), method200 proceeds to (2).

At (2), the IFC generates a first, non-optimized version of databasecode to upload to the relational database, from (2), method 200 proceedsto (3).

At (3), a simulator (not illustrated in FIG. 1), can be used to checkthe generated, non-optimized code for errors. Example checks can includecomparing existing database artifacts against the generated codeartifacts, etc. If any errors are found, a user can be notified and makecorrections, possibly requiring starting method 200 from (1). From (3),method 200 proceeds to (4).

At (4), a synthesizer (not illustrated in FIG. 1) optimizes correct,generated, non-optimized code into optimized code (a “databaseintegration flow” (DIF)). The synthesizer then deploys the DIF to therelational database. After (4), method 200 stops.

In some implementations, the simulator of (3) and the synthesizer of (4)can be part of the IFC. In other implementations, the simulator and/orsynthesizer can stand alone in relation to the IFC on the databaseserver 150 and/or other component of the EDCS 100.

FIGS. 3A and 3B are block diagrams 300 a and 300 b, respectively,illustrating design-time and run-time aspects of a providedsplitter-aggregator iFlow diagram 202 compiled to a relational database156 according to an implementation. Referring to FIG. 3A, a receivedsplitter-aggregator iFlow diagram 202 is illustrated as a collaborationdiagram with a sender 302, integration process 304, and receiver 306.The sender 302 is shown communicating with the integration process 304using the simple object access protocol (SOAP). The integration process304 is also shown as communicating with the receiver 306 using SOAP. Theintegration process 304 is illustrated as an application to (simplified)take a received message containing text, split it into constituent wordsand count the number of each word. The integration processes indicates astart 308 and an end 310 to the process. Steps of the process includesplitters 312 a and 312 b, a filter 314, and an aggregator 316.

Referring to FIG. 3B, consistent with the description of FIG. 2, theprovided iFlow diagram 202 is compiled, optimized into optimized code,and the optimized code deployed to the relational database 156 as ascheduler and generated database code DIF runtime 317. Note that thisexample assumes that both the sender 302 (Application A) and receiver306 (Application B) are sharing the same relational database 156 (referto FIG. 4 below for this category (C-1)). Here, sender 302 writes data,for example one or more messages containing text, from database tablesassociated with Application A to a start table 320. The sender thenissues a database commit. The scheduler 322 detects the change to thestart table 320, triggers get messages from the start table (reads data,deletes data from the start table, and passes the data to the splitter324 a), moves the messages according to the DIF (324 a→324 b→326→328),puts outgoing messages (result data) into the end table 330, and commitsthe transaction. The receiver 306 detects the change to end table 330,retrieves the result data from the end table 330 and writes theretrieved result data to application B tables 332. Note that in someimplementations the scheduler 322 can execute outside the database(e.g., on a separate server) as a non-database construct (seedescription of IFC above in relation to FIG. 1) and “listens” for newdata to be written to the start table 320. In alternate implementations,the scheduler can execute on the database as a form of applicationserver or polling application. In other implementations, the schedulercould be implemented as a database trigger or in any suitable way topermit detection of changes to the start table 320 and the start of theDIF runtime logic.

A channel represents a unidirectional, point-to-point (P2P)communication from sender 302 to receiver 306. It usually containsintegration logic by chaining EIPs (e.g., 324 a, 324 b, 326, and 328).The channel endpoints (e.g., database start table 320 and end table 330)receive/produce messages. The channel endpoints represent entry/exitpoints for messages into the DIF runtime 317, capture relational messagebody data, and are generated by the IFC 160 as (persistent). The tablesbelong to the database integration flow of the DIF runtime 317. In someimplementations, a body can consist of zero-to-n records/rows. The bodyis part of the message. Since the message is expressed in a relationalmodel, the body is able to carry zero-to-n records/rows (of a transient/persistent table). In some implementations, if the row count is zero, anempty message is sent. Start table 320/end table 330 and the channel canbe typed (e.g., if the relational model of the payload is known) oruntyped (e.g., data is represented as a character large object (CLOB)and/or binary large object (BLOB)). In the illustrated example, sender302 will fill the start table 320 with a text from its application table318, and the receiver 306 will read from the end table 330 the result ofthe DIF runtime 317.

To decouple the sender 302/receiver 306 and the DIF runtime 317, eachparticipant has its own transaction context: The sender 302 puts amessage on a channel by generating a new message instance and insertingthe payload into a start table 320 (a ID/text combination in ourexample). The sender 302 then commits its transaction T(S) to make thenew message visible to the DIF runtime 317 (left TA-boundary in FIG. 3).The DIF runtime 317 employs another transaction T(R) to process themessage. T(R) removes the message from the start table 320, does theprocessing, and finally writes the result message (as result data) tothe end table 330 (the resulting ID/bag-of-words mapping). T(R) commitsthe transaction to make the message visible to the receiver 306 (rightTA-boundary in FIG. 4). The receiver 306 takes the message from thechannel by removing the payload from the end table 330 and “cleaning up”entries from the message tables. The receiver 306 then commits itstransaction T(E). Transactional decoupling among the participantsensures that channel processing does not affect applicationtransactions. The IFC 160 generates stored procedures for Applications Aand B (associated with sender 302 and receiver 306, respectively) tosimplify the send/receive process and to avoid access toruntime-internal tables. These procedures also create/remove entriesin/from message/header/attachment tables.

The relational database 156 constructs generated by the IFC 160 resultin a pipeline that implements message store-and-forward processing (seebelow). A pipeline represents a message channel and consists of anordered set of processing functions (e.g., filter, and mapping),relations (e.g., routing, broadcasting) and result sets of thosefunctions. The result sets of a function or relation can be the input tothe next function. The sequence of functions and result sets form themessage channel. A database pipeline is an IFC-generated implementationof a message channel. For its implementation stored procedures and SQLare used for the following two purposes: (1) to express/executeintegration semantics of the iFlow diagram 202 for which the pipelinewas generated; and (2) to handle the lifecycle of a message (see below).The result sets of processing functions or relations can betransient/persistent database tables. In some implementations, functionsand relations are relational algebra operators and produce result setscompliant with a suitable database message format.

Start and end tables, 320 and 330 respectively, are native persistencepoints. Messages are moved along the pipeline from one persistence pointto the next. An example message lifecycle can be: (1) a runtimetransaction (T) reads a message from a persistence point (source table)and processes the message (by executing the functions and relations onthe pipeline) until the next persistence point (target table) is reached(implemented by a stored procedure, purpose P1 in the previous section).Intermediate results can be captured in transient tables (e.g., “move”as in FIG. 3). T stores the result message in a persistent target table(e.g., “write” as in FIG. 3) and removes the corresponding message fromthe persistent source table (e.g., “read/delete” as in FIG. 3). T thencommits to make the change visible. This is implemented in a “lifecycleprocedure” (see purpose (2) above).

Transactional processing ensures that in any point in time, a message isstored exactly in one persistence point (as seen from an observingtransaction T). Transactional processing also ensures the recoverabilityof the system: In-flight messages (currently in progress on the channel)are automatically rolled back to a consistent state (to the lastpersistence point, e.g., in the start table 320) in case of a DB crash.EIPs on the channel might define further persistence points (e.g., formonitoring) that result in persistent channel tables. By default, IFC160 tries to use transient (in-memory) tables for intermediate resultsto reduce writes to the persistent store (as illustrated in FIG. 3).

The IFC 160 makes use of the access control capabilities of therelational database 156 to control access to application and runtimetables. In the provided example, Application A (sender 302) has accessto its own tables and write access to the start table 320. Application B(receiver 306) has access to its own tables and read/delete access onthe end table 330. Remaining tables belong to the DIF runtime 317 andneither application A nor application B has access. In someimplementations, the DIF runtime 317 can be accessed by an IFC 160administrator.

Since a channel is an abstract construct, the IFC 160 has freedom togenerate a relational database-156 specific implementation for thechannel. The IFC 160 generates code that processes messages in bulk modefor which a database system is the ideal runtime. Furthermore the IFC160 can create multiple incarnations of the same channel to scale-outchannel processing, if necessary. As will be apparent to those of skillin the art, further system-relevant characteristics such as stability,high availability, can be inherited from the relational database 156.

FIG. 4 is a block diagram of a category 1 (C-1) integrationconfiguration 400 according to an implementation. This configuration isdesignated as “local”/“local” in that both the sender/receiverapplications on associated application servers 102 reside in the samebusiness system and share a common (local) relational database system150 but not the same schema. The C-1 configuration can potentiallyoccurs with business software suites, where hundreds or thousands ofapplications are implemented on a similar 3-tier software stack with asingle relational database system 150 in a backend environment. Thegearwheel 402 depicts the location of integration semantics processingin the database system, which is shared by the sending and receivingapplications on associated application server 102. All operations arerelational database-local.

If a sender application, for example Application A, needs to send datato a receiver application, for example Application B, that uses the samerelational database system 156, the following steps occur: 1) the senderselects the relational data to be sent and inserts the data into adatabase table; 2) a DIF on the relational database system 150 picks upthe data from the database table and processes it (transformation,routing, etc.); 3) the DIF writes the data into a database table knownby the receiver Application B; 4) the receiver Application B reads therelational data and inserts the data into its own database tables. Alloperations are relational database-internal. Note that nosystem-boundaries are traversed, no data conversion (to/from XML orother suitable messaging format) is required, no protocoltransformations are necessary, and no non-relational operations need tobe executed.

FIG. 5 is a block diagram of a category 2 (C-2) integrationconfiguration 500 according to an implementation. This configuration isdesignated as “local”/“external” or “external”/“local” in that anapplication (either sender 302 or receiver 306) needs to access“external” data. For example, a business application (Application B)analyzes social network feeds sent from sender 302/Application A forsocial sentiment analysis. Sender 302 and receiver 306 do not share thesame relational database system as each have their own relationaldatabase system, 150-302/150-306 respectively. The C-2 configurationuses a DIF runtime (see 317 and discussion related to FIG. 3) on each ofthe sender 150-302 (outbound) and receiver 150-306 (inbound) associatedrelational database systems. The gearwheels 502 a/502 b depict thelocation of integration semantics processing in the relational databasesystems 150-302/150-306 for sender 302/receiver 306, respectively. Datais transported 504 (in relational format) from the sender 302 relationaldatabase system 150 to the receiver 306 relational database system 150.All operations (except data transport 504 between relational databasesystems—by message, etc.) are relational database-local.

FIG. 6 is a block diagram of a category 3 (C-3) integrationconfiguration 600 according to an implementation. This configuration isdesignated as “external”/“external” in that an application (eithersender 302 or receiver 306) needs to access data present on a non-localrelational database system associated with another application. As inthe C-2 configuration, sender 302 and receiver 306 do not share the samerelational database system as each have their own relational databasesystem. The sender 302/receiver 306 applications reside on differentsystems and communication is mediated by a dedicated integrationdatabase system 602. The gearwheel 604 depicts the location ofintegration semantics processing in the mediating dedicated integrationdatabase system 602. In this configuration, the dedicated integrationdatabase system 602 can act as MOM but be more efficient than firstprocessing messages using an application, application server, and/or thelike prior to utilizing a relational database 156. Here, the dedicatedintegration database system 602 can directly handle messages. In someimplementations, certain functionally can be designated to be handled bythe dedicated integration database system 602, for exampledatabase-intensive integration scenarios, monitoring and alerting, etc.while remaining non-database-intensive functionality can be handled byan application, application server, and/or the like.

Configurations C-1, C2, and C-3 illustrate uses of DIF runtimes forintegration functionality. In some implementations, the use of DIFruntimes can replace or be complementary to existing EAI solutions(e.g., MOM systems) for particulardatabase-intensive/database-appropriate functionality by removing all orsome need for application-server-based integration functionality.

FIG. 7 is a block diagram of a current state integration configuration700 according to an implementation. For an Application A (sender)102-302 needs to send data in a message using a particular EAI solutionto an Application B (receiver) 102-306, the following (simplified)processing steps are typically necessary: 1) the sender 102-302 extractssender-relational-format data to be sent from a sender database 150-302;2) the sender 102-302 converts the extracted sender-relational-formatdata to an EAI-compatible, GDX-formatted first message; 3) the sender102-302 passes the converted data to a particular EAI solution 702(which runs on its own software stack) in the EAI-compatible,GDX-formatted first message; 4) the EAI solution 702 processes thereceived data retrieved from the EAI-compatible, GDX-formatted firstmessage (e.g., transformation, receiver determination, and the like)using EAI solution logic/EAI solution database 150-702; 5) the EAIsolution 702 passes the data in a receiver-compatible, GDX-formattedsecond message to the receiver 102-306; 6) the receiver 102-306 convertsthe data in the receiver-compatible, GDX-formatted second message to areceiver-compatible relational format; and 7) the receiver 102-306inserts the data into its database 150-306 using the receiver-compatiblerelational format. In total, the data is converted twice (senderrelational format-to-EAI-compatible, GDX-format and receiver-compatible,GDX-format-to-receiver relational format) and crosses four systemboundaries (sender database-to-application server, applicationserver-to-EAI solution, EAI solution-to-application server, applicationserver-to-receiver database), resulting in high resource overhead permessage to the receiver.

FIG. 8 is a flow chart illustrating a method 800 for providing C-1application integration functionality (as illustrated in FIG. 4)directly on a relational database according to an implementation. Forclarity of presentation, the description that follows generallydescribes method 800 in the context of FIGS. 1-7. However, it will beunderstood that method 800 may be performed, for example, by any othersuitable system, environment, software, and hardware, or a combinationof systems, environments, software, and hardware as appropriate. In someimplementations, various steps of method 800 can be run in parallel, incombination, in loops, or in any order.

At 802, relational data from a source table on a database and associatedwith a sending first application is selected to be sent to a receivingsecond application. The second application has access to the samedatabase. From 802, method 800 proceeds to 804.

At 804, the selected relational data is inserted into a database starttable on the database. In some implementations, the sending applicationissues a commit operation to make the relational data visible to thedatabase integration flow (DIF) runtime. From 804, method 800 proceedsto 806.

At 806, the change to the start table is detected. For example, ascheduling application (internal and/or external to the database) can“listen” to detect the change to the start table. In otherimplementations, a database trigger can be used. In still otherimplementations, a polling application (internal and/or external to thedatabase) could poll the database start table for changes. As will beappreciated by those of skill in the art, any suitable detection methodmay be used to detect the change to the start table. From 806, method800 proceeds to 808.

At 808, the relational data inserted into the start table is retrieved.For example the scheduler could issue get operations to retrieve therelational data. In some implementations, the retrieved relational datais deleted from the start table once retrieved. The retrieved relationaldata is passed to the DIF runtime. From 808, method 800 proceeds to 810.

At 810, The relational data is processed accordingly by the DIF runtime(e.g., as illustrated by the FIG. 3 splitter/aggregator DIF runtime)into result data. From 810, method 800 proceeds to 812.

At 812, the result data is inserted into a database end table for accessby the receiving application. In some implementations, the DIF runtimeissues a commit operation. From 812, method 800 proceeds to 814.

At 814, the receiving application detects a change in the end table. Insome implementations, the receiving application can use detectionmethods similar to that at 806 and/or any other suitable method. From814, method 800 proceeds to 816.

At 816, the receiving application retrieves the result data from the endtable. In some implementations, the result data is deleted from the endtable once retrieved. From 816, method 800 proceeds to 818.

At 818, the receiving application inserts the retrieved result data intoa target database table associated with the receiving application. After818, method 800 stops.

FIG. 9A is a flow chart illustrating a method 900 a for providing C-2application outbound integration functionality (as illustrated in FIG.5) directly on a relational database according to an implementation. Forclarity of presentation, the description that follows generallydescribes method 900 a in the context of FIGS. 1-8. However, it will beunderstood that method 900 a may be performed, for example, by any othersuitable system, environment, software, and hardware, or a combinationof systems, environments, software, and hardware as appropriate. In someimplementations, various steps of method 900 a can be run in parallel,in combination, in loops, or in any order.

At 902 a, relational data from a source table on a database andassociated with a sending first application is selected to be sent to areceiving second application. From 902 a, method 900 a proceeds to 904a.

At 904 a, the selected relational data is inserted into a database starttable on the database. In some implementations, the sending applicationissues a commit operation to make the relational data visible to thedatabase integration flow (DIF) runtime. From 904 a, method 900 aproceeds to 906 a.

At 906 a, the change to the start table is detected. For example, ascheduling application (internal and/or external to the database) can“listen” to detect the change to the start table. In otherimplementations, a database trigger can be used. In still otherimplementations, a polling application (internal and/or external to thedatabase) could poll the database start table for changes. As will beappreciated by those of skill in the art, any suitable detection methodmay be used to detect the change to the start table. From 906 a, method900 a proceeds to 908 a.

At 908 a, the relational data inserted into the start table isretrieved. For example the scheduler could issue get operations toretrieve the relational data. In some implementations, the retrievedrelational data is deleted from the start table once retrieved. Theretrieved relational data is passed to the DIF runtime. From 908 a,method 900 a proceeds to 910 a.

At 910 a, The relational data is processed accordingly by the DIFruntime (e.g., as illustrated by the FIG. 3 splitter/aggregator DIFruntime) into result data. From 910 a, method 900 a proceeds to 912 a.

At 912 a, the result data is inserted into a database end table to besent to the receiving application. In some implementations, the DIFruntime issues a commit operation. From 912 a, method 900 a proceeds to914 a.

At 914 a, a change is detected in the end table. In someimplementations, detection methods similar to that at 906 and/or anyother suitable method can be used. From 914 a, method 900 a proceeds to916 a.

At 916 a, the result data is retrieved from the end table. In someimplementations, the result data is deleted from the end table onceretrieved. From 916 a, method 900 a proceeds to 918 a.

At 918 a, the retrieved relational data is serialized into a genericdata exchange (GDX) format. In other implementations, any suitableformat, structure, etc. can be used to package the relational data fortransmission. From 918 a, method 900 a proceeds to 920 a.

At 920 a, the serialized data is passed to a transmission application(e.g., a sending-application-associated message-oriented middleware(MOM) or enterprise service bus (ESB) (not illustrated in FIG. 5)) fortransmission to the receiving application. From 920 a, method 900 aproceeds to 922 a.

At 922 a, the transmission application transmits the serialized data tothe receiving application. After 922 a, method 900 a stops.

FIG. 9B is a flow chart illustrating a method 900 b for providing C-2application inbound integration functionality (as illustrated in FIG. 5)directly on a relational database according to an implementation. Forclarity of presentation, the description that follows generallydescribes method 900 b in the context of FIGS. 1-9A. However, it will beunderstood that method 900 b may be performed, for example, by any othersuitable system, environment, software, and hardware, or a combinationof systems, environments, software, and hardware as appropriate. In someimplementations, various steps of method 900 b can be run in parallel,in combination, in loops, or in any order.

At 902 b, serialized data is received by a reception application (e.g.,a receiving-application-associated MOM/ESB (not illustrated in FIG. 5)).The received serialized data is deserialized into a relational format bythe reception application. From 902 b, method 900 b proceeds to 904 b.

At 904 b, the relational data is inserted into a database start table onthe receiving application database. In some implementations, thereception application issues a commit operation to make the relationaldata visible to the database integration flow (DIF) runtime. From 904 b,method 900 b proceeds to 906 b.

At 906 b, the change to the start table is detected. For example, ascheduling application (internal and/or external to the database) can“listen” to detect the change to the start table. In otherimplementations, a database trigger can be used. In still otherimplementations, a polling application (internal and/or external to thedatabase) could poll the database start table for changes. As will beappreciated by those of skill in the art, any suitable detection methodmay be used to detect the change to the start table. From 906 b, method900 b proceeds to 908 b.

At 908 b, the relational data inserted into the start table isretrieved. For example the scheduler could issue get operations toretrieve the relational data. In some implementations, the retrievedrelational data is deleted from the start table once retrieved. Theretrieved relational data is passed to the DIF runtime. From 908 b,method 900 b proceeds to 910 b.

At 910 b, The relational data is processed accordingly by the DIFruntime (e.g., as illustrated by the FIG. 3 splitter/aggregator DIFruntime) into result data. From 910 b, method 900 b proceeds to 912 b.

At 912 b, the result data is inserted into a database end table foraccess by the receiving application. In some implementations, the DIFruntime issues a commit operation. From 912 b, method 900 b proceeds to914 b.

At 914 b, the receiving application detects a change in the end table.In some implementations, the receiving application can use detectionmethods similar to that at 906 and/or any other suitable method. From914 b, method 900 b proceeds to 916 b.

At 916 b, the receiving application retrieves the result data from theend table. In some implementations, the result data is deleted from theend table once retrieved. From 916 b, method 900 b proceeds to 918 b.

At 918 b, the receiving application inserts the retrieved result datainto a target database table on the receiving application database.After 918 b, method 900 b stops.

FIG. 10 is a flow chart illustrating a method 1000 for providing C-3application integration functionality (as illustrated in FIG. 6)directly on a relational database according to an implementation. Forclarity of presentation, the description that follows generallydescribes method 1000 in the context of FIGS. 1-8 and 9A-9B. However, itwill be understood that method 1000 may be performed, for example, byany other suitable system, environment, software, and hardware, or acombination of systems, environments, software, and hardware asappropriate. In some implementations, various steps of method 1000 canbe run in parallel, in combination, in loops, or in any order.

At 1002, serialized data is received from a first application by areception application (e.g., a MOM/ESB (not illustrated in FIG. 6))).The received serialized data is deserialized into a relational format.From 1002, method 1000 proceeds to 1004.

At 1004, the relational data is inserted into a database start table onthe receiving application database. In some implementations, thereception application issues a commit operation to make the relationaldata visible to the database integration flow (DIF) runtime. From 1004,method 1000 proceeds to 1006.

At 1006, the change to the start table is detected. For example, ascheduling application (internal and/or external to the database) can“listen” to detect the change to the start table. In otherimplementations, a database trigger can be used. In still otherimplementations, a polling application (internal and/or external to thedatabase) could poll the database start table for changes. As will beappreciated by those of skill in the art, any suitable detection methodmay be used to detect the change to the start table. From 1006, method1000 proceeds to 1008.

At 1008, the relational data inserted into the start table is retrieved.For example the scheduler could issue get operations to retrieve therelational data. In some implementations, the retrieved relational datais deleted from the start table once retrieved. The retrieved relationaldata is passed to the DIF runtime. From 1008, method 1000 proceeds to1010.

At 1010, the relational data is processed accordingly by the DIF runtime(e.g., as illustrated by the FIG. 3 splitter/aggregator DIF runtime)into result data. From 1010, method 1000 proceeds to 1012.

At 1012, the result data is inserted into a database end table foraccess by the receiving application. In some implementations, the DIFruntime issues a commit operation. From 1012, method 1000 proceeds to1014.

At 1014, the receiving application detects a change in the end table. Insome implementations, the receiving application can use detectionmethods similar to that at 1006 and/or any other suitable method. From1014, method 1000 proceeds to 1016.

At 1016, the receiving application retrieves the result data from theend table. In some implementations, the result data is deleted from theend table once retrieved. From 1016, method 1000 proceeds to 1018.

At 1018, the retrieved relational data is serialized into a generic dataexchange (GDX) format. In other implementations, any suitable format,structure, etc. can be used to package the relational data fortransmission. From 1018, method 1000 proceeds to 1020.

At 1020, the serialized data is passed to a transmission application(e.g., a MOM/ESB (not illustrated in FIG. 6)) for transmission to asecond application. From 1020, method 1000 proceeds to 1022.

At 1022, the transmission application transmits the serialized data tothe second application. After 1022, method 1000 stops.

Although the concepts herein have been described primarily in terms ofan in-memory database, the use of in-memory database technologiesdescribe only one possible implementation and is not intended to limitthe disclosure in any way. Those of skill in the art will appreciatethat various non-in-memory database technologies can be substituted andappropriate changes made to the described technology without deviatingfrom the spirit and scope of the disclosure. The present disclosure isnot intended to be limited to the described and/or illustratedimplementations, but is to be accorded the widest scope consistent withthe principles and features disclosed herein.

Implementations of the subject matter and the functional operationsdescribed in this specification can be implemented in digital electroniccircuitry, in tangibly-embodied computer software or firmware, incomputer hardware, including the structures disclosed in thisspecification and their structural equivalents, or in combinations ofone or more of them. Implementations of the subject matter described inthis specification can be implemented as one or more computer programs,i.e., one or more modules of computer program instructions encoded on atangible, non-transitory computer-storage medium for execution by, or tocontrol the operation of, data processing apparatus. Alternatively or inaddition, the program instructions can be encoded on anartificially-generated propagated signal, e.g., a machine-generatedelectrical, optical, or electromagnetic signal that is generated toencode information for transmission to suitable receiver apparatus forexecution by a data processing apparatus. The computer-storage mediumcan be a machine-readable storage device, a machine-readable storagesubstrate, a random or serial access memory device, or a combination ofone or more of them.

The term “data processing apparatus” refers to data processing hardwareand encompasses all kinds of apparatus, devices, and machines forprocessing data, including by way of example, a programmable processor,a computer, or multiple processors or computers. The apparatus can alsobe or further include special purpose logic circuitry, e.g., a centralprocessing unit (CPU), a FPGA (field programmable gate array), or anASIC (application-specific integrated circuit). In some implementations,the data processing apparatus and/or special purpose logic circuitry maybe hardware-based and/or software-based. The apparatus can optionallyinclude code that creates an execution environment for computerprograms, e.g., code that constitutes processor firmware, a protocolstack, a database management system, an operating system, or acombination of one or more of them. The present disclosure contemplatesthe use of data processing apparatuses with or without conventionaloperating systems, for example LINUX, UNIX, WINDFLOWS, MAC OS, ANDROID,IOS or any other suitable conventional operating system.

A computer program, which may also be referred to or described as aprogram, software, a software application, a module, a software module,a script, or code, can be written in any form of programming language,including compiled or interpreted languages, or declarative orprocedural languages, and it can be deployed in any form, including as astand-alone program or as a module, component, subroutine, or other unitsuitable for use in a computing environment. A computer program may, butneed not, correspond to a file in a file system. A program can be storedin a portion of a file that holds other programs or data, e.g., one ormore scripts stored in a markup language document, in a single filededicated to the program in question, or in multiple coordinated files,e.g., files that store one or more modules, sub-programs, or portions ofcode. A computer program can be deployed to be executed on one computeror on multiple computers that are located at one site or distributedacross multiple sites and interconnected by a communication network.While portions of the programs illustrated in the various figures areshown as individual modules that implement the various features andfunctionality through various objects, methods, or other processes, theprograms may instead include a number of sub-modules, third-partyservices, components, libraries, and such, as appropriate. Conversely,the features and functionality of various components can be combinedinto single components as appropriate.

The processes and logic flows described in this specification can beperformed by one or more programmable computers executing one or morecomputer programs to perform functions by operating on input data andgenerating output. The processes and logic flows can also be performedby, and apparatus can also be implemented as, special purpose logiccircuitry, e.g., a CPU, a FPGA, or an ASIC.

Computers suitable for the execution of a computer program can be basedon general or special purpose microprocessors, both, or any other kindof CPU. Generally, a CPU will receive instructions and data from aread-only memory (ROM) or a random access memory (RAM) or both. Theessential elements of a computer are a CPU for performing or executinginstructions and one or more memory devices for storing instructions anddata. Generally, a computer will also include, or be operatively coupledto, receive data from or transfer data to, or both, one or more massstorage devices for storing data, e.g., magnetic, magneto-optical disks,or optical disks. However, a computer need not have such devices.Moreover, a computer can be embedded in another device, e.g., a mobiletelephone, a personal digital assistant (PDA), a mobile audio or videoplayer, a game console, a global positioning system (GPS) receiver, or aportable storage device, e.g., a universal serial bus (USB) flash drive,to name just a few.

Computer-readable media (transitory or non-transitory, as appropriate)suitable for storing computer program instructions and data include allforms of non-volatile memory, media and memory devices, including by wayof example semiconductor memory devices, e.g., erasable programmableread-only memory (EPROM), electrically-erasable programmable read-onlymemory (EEPROM), and flash memory devices; magnetic disks, e.g.,internal hard disks or removable disks; magneto-optical disks; andCD-ROM, DVD+/-R, DVD-RAM, and DVD-ROM disks. The memory may storevarious objects or data, including caches, classes, frameworks,applications, backup data, jobs, web pages, web page templates, databasetables, repositories storing business and/or dynamic information, andany other appropriate information including any parameters, variables,algorithms, instructions, rules, constraints, or references thereto.Additionally, the memory may include any other appropriate data, such aslogs, policies, security or access data, reporting files, as well asothers. The processor and the memory can be supplemented by, orincorporated in, special purpose logic circuitry.

To provide for interaction with a user, implementations of the subjectmatter described in this specification can be implemented on a computerhaving a display device, e.g., a CRT (cathode ray tube), LCD (liquidcrystal display), or plasma monitor, for displaying information to theuser and a keyboard and a pointing device, e.g., a mouse, trackball, ortrackpad by which the user can provide input to the computer. Input mayalso be provided to the computer using a touchscreen, such as a tabletcomputer surface with pressure sensitivity, a multi-touch screen usingcapacitive or electric sensing, or other type of touchscreen. Otherkinds of devices can be used to provide for interaction with a user aswell; for example, feedback provided to the user can be any form ofsensory feedback, e.g., visual feedback, auditory feedback, or tactilefeedback; and input from the user can be received in any form, includingacoustic, speech, or tactile input. In addition, a computer can interactwith a user by sending documents to and receiving documents from adevice that is used by the user; for example, by sending web pages to aweb browser on a user's client device in response to requests receivedfrom the web browser.

The term “graphical user interface,” or GUI, may be used in the singularor the plural to describe one or more graphical user interfaces and eachof the displays of a particular graphical user interface. Therefore, aGUI may represent any graphical user interface, including but notlimited to, a web browser, a touch screen, or a command line interface(CLI) that processes information and efficiently presents theinformation results to the user. In general, a GUI may include aplurality of user interface (UI) elements, some or all associated with aweb browser, such as interactive fields, pull-down lists, and buttonsoperable by the business suite user. These and other UI elements may berelated to or represent the functions of the web browser.

Implementations of the subject matter described in this specificationcan be implemented in a computing system that includes a back-endcomponent, e.g., as a data server, or that includes a middlewarecomponent, e.g., an application server, or that includes a front-endcomponent, e.g., a client computer having a graphical user interface ora Web browser through which a user can interact with an implementationof the subject matter described in this specification, or anycombination of one or more such back-end, middleware, or front-endcomponents. The components of the system can be interconnected by anyform or medium of wireline and/or wireless digital data communication,e.g., a communication network. Examples of communication networksinclude a local area network (LAN), a radio access network (RAN), ametropolitan area network (MAN), a wide area network (WAN), WorldwideInteroperability for Microwave Access (WIMAX), a wireless local areanetwork (WLAN) using, for example, 802.11 a/b/g/n and/or 802.20, all ora portion of the Internet, and/or any other communication system orsystems at one or more locations. The network may communicate with, forexample, Internet Protocol (IP) packets, Frame Relay frames,Asynchronous Transfer Mode (ATM) cells, voice, video, data, and/or othersuitable information between network addresses.

The computing system can include clients and servers. A client andserver are generally remote from each other and typically interactthrough a communication network. The relationship of client and serverarises by virtue of computer programs running on the respectivecomputers and having a client-server relationship to each other.

In some implementations, any or all of the components of the computingsystem, both hardware and/or software, may interface with each otherand/or the interface using an application programming interface (API)and/or a service layer. The API may include specifications for routines,data structures, and object classes. The API may be either computerlanguage independent or dependent and refer to a complete interface, asingle function, or even a set of APIs. The service layer providessoftware services to the computing system. The functionality of thevarious components of the computing system may be accessible for allservice consumers via this service layer. Software services providereusable, defined business functionalities through a defined interface.For example, the interface may be software written in JAVA, C++, orother suitable language providing data in extensible markup language(XML) format or other suitable format. The API and/or service layer maybe an integral and/or a stand-alone component in relation to othercomponents of the computing system. Moreover, any or all parts of theservice layer may be implemented as child or sub-modules of anothersoftware module, enterprise application, or hardware module withoutdeparting from the scope of this disclosure.

While this specification contains many specific implementation details,these should not be construed as limitations on the scope of anyinvention or on the scope of what may be claimed, but rather asdescriptions of features that may be specific to particularimplementations of particular inventions. Certain features that aredescribed in this specification in the context of separateimplementations can also be implemented in combination in a singleimplementation. Conversely, various features that are described in thecontext of a single implementation can also be implemented in multipleimplementations separately or in any suitable sub-combination. Moreover,although features may be described above as acting in certaincombinations and even initially claimed as such, one or more featuresfrom a claimed combination can in some cases be excised from thecombination, and the claimed combination may be directed to asub-combination or variation of a sub-combination.

Similarly, while operations are depicted in the drawings in a particularorder, this should not be understood as requiring that such operationsbe performed in the particular order shown or in sequential order, orthat all illustrated operations be performed, to achieve desirableresults. In certain circumstances, multitasking and parallel processingmay be advantageous. Moreover, the separation and/or integration ofvarious system modules and components in the implementations describedabove should not be understood as requiring such separation and/orintegration in all implementations, and it should be understood that thedescribed program components and systems can generally be integratedtogether in a single software product or packaged into multiple softwareproducts.

Particular implementations of the subject matter have been described.Other implementations, alterations, and permutations of the describedimplementations are within the scope of the following claims as will beapparent to those skilled in the art. For example, the actions recitedin the claims can be performed in a different order and still achievedesirable results.

Accordingly, the above description of example implementations does notdefine or constrain this disclosure. Other changes, substitutions, andalterations are also possible without departing from the spirit andscope of this disclosure.

What is claimed is:
 1. A computer-implemented method comprising:inserting relational data into a start table of a database; detecting achange in the start table; retrieving the inserted relational data fromthe start table; processing, using a computer, the relational data usinga database integration flow runtime into result data; inserting theresult data into an end table of the database; detecting a change in theend table; and retrieving the result data from the end table.
 2. Themethod of claim 1, further comprising selecting the relational data froma source table of the database.
 3. The method of claim 1, furthercomprising inserting the result data into a target table of thedatabase.
 4. The method of claim 1, further comprising: serializing theresult data; passing the serialized data to a transmission application;and transmitting the serialized data.
 5. The method of claim 3, furthercomprising deserializing received data into relational data.
 6. Themethod of claim 5, further comprising: serializing the result data fortransmission; passing the serialized data to a transmission application;and transmitting the serialized data.
 7. A non-transitory,computer-readable medium storing computer-readable instructionsexecutable by a computer to: insert relational data into a start tableof a database; detect a change in the start table; retrieve the insertedrelational data from the start table; process the relational data usinga database integration flow runtime into result data; insert the resultdata into an end table of the database; detect a change in the endtable; and retrieve the result data from the end table.
 8. The medium ofclaim 7, further comprising instructions to select the relational datafrom a source table of the database.
 9. The medium of claim 7, furthercomprising instructions to insert the result data into a target table ofthe database.
 10. The medium of claim 7, further comprising instructionsto: serialize the result data; pass the serialized data to atransmission application; and transmit the serialized data.
 11. Themedium of claim 9, further comprising instructions to deserializereceived data into relational data.
 12. The medium of claim 11, furthercomprising instructions to: serialize the result data for transmission;pass the serialized data to a transmission application; and transmit theserialized data.
 13. A computer-implemented system comprising: a memoryconfigured to hold a database integration flow runtime; a processorinteroperably coupled with the memory and configured to performoperations comprising: insert relational data into a start table of adatabase; detect a change in the start table; retrieve the insertedrelational data from the start table; process the relational data usingthe database integration flow runtime into result data; insert theresult data into an end table of the database; detect a change in theend table; and retrieve the result data from the end table.
 14. Thesystem of claim 13, further configured to select the relational datafrom a source table of the database.
 15. The system of claim 13, furtherconfigured to insert the result data into a target table of thedatabase.
 16. The system of claim 13, further configured to: serializethe result data; pass the serialized data to a transmission application;and transmit the serialized data.
 17. The system of claim 15, furtherconfigured to deserialize received data into relational data.
 18. Thesystem of claim 17, further configured to: serialize the result data fortransmission; pass the serialized data to a transmission application;and transmit the serialized data.